package com.xxxt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xxxt.entity.ClassGrade;
import com.xxxt.entity.Grade;

public interface GradeMapper {
	
	List<Grade> selcetAllGradeBySpecialtyId(String specialtyId);
	
	List<Grade> selcetAllGrade();
	
	List<Grade> selcetAllPageGradeBySpecialtyId(String specialtyId);
	
	Grade selcetOneGradeByGradeId(String gradeId);
	
	boolean insertGrade(Grade grade);
	
	boolean deleteGrade(String gradeId);
	
	boolean updateGrade(@Param("grade") String gradeName,@Param("specialtyId") String specialtyId,@Param("id") String id);

	List<ClassGrade> selectStudentByTnoAndSpecialty(List<Grade> grades);
	
	Grade selectGradeByName(@Param("grade")String grade,@Param("specialtyId")String specialtyId);
}
